Setting advanced connection properties
The table below describes the settings in the Advanced tab.
| Setting | Description |
|---|---|
|
File Format |
Expand this section to specify or view the file format settings. |
|
Select either Text or Sequence. Information note
When using Text as the target storage format, new lines as part of the data values are not supported (due to an Apache Hadoop limitation). Best practice is to use Sequence as the target storage format. |
|
|
Field delimiter |
The delimiter that will be used to separate fields in the target file. The default is |
|
Null value |
The value that will be used to indicate a null value in the target file. Example (where @ is the null value): mike,male,295678 sara,female,@ |
|
Escape character |
The escape character is used to escape the field delimiter character. When a field delimiter is escaped, it is interpreted as actual data, and not as a field delimiter. Example (where \ is the escape character and a comma is the field delimiter): sunroof\,power-steering When using Other SerDe: The escape character is used to escape the quote character. Example (where \ is the escape character and double quotes is the quote character): "\"sunroof, power-steering\"" |
|
Add metadata header |
When the target storage format is set to Text, you can optionally add a header row to the data files. The header row can contain the source column names and/or the intermediate (i.e. Replicate) data types. Example of a target file with a header row when both With column names and With data types are selected: Position:DECIMAL(38,0),Color:VARCHAR(10) 1,"BLUE" 2,"BROWN" 3,"RED" ... |
|
File Attributes |
Expand this section to specify or view the file attributes. |
|
Maximum file size |
Specify the maximum file size of each target file. When the data reaches the maximum size, the file will be closed and written to the specified target folder. |
|
Expand this section to specify or view change processing settings. |
|
| Apply/store changes when File size reaches | Specify the minimum size of the data required to create a file in idle state. |
| Apply/store changes when Elapsed time reaches | Specify the maximum time to wait before applying the changes in idle state. |
| Proxy Server | Expand this section to specify or view proxy settings. |
|
Use proxy server |
Select this option to access Amazon S3 via a proxy server. |
|
Host name |
The host name of the proxy server. |
|
Port |
The port via which to access the proxy server. |
|
User name |
The user name for accessing the proxy server. |
|
Password |
The password for accessing the proxy server. |
|
Scheme |
Select which protocol to use to access the server (HTTP or HTTPS). In order to use HTTPS, you must first install the CA certificate that signed the proxy’s certificate on the Replicate Server machine. Do this as follows:
|
To facilitate rapid delivery of DDL messages, files are uploaded immediately, regardless of the specified File size reaches or Elapsed time reaches values.
Internal parameters
Internal parameters are parameters that are not exposed in the UI. You should only use them if instructed by Qlik Support.
To add internal Qlik Replicate parameters:
-
Click the Internal Parameters link.
The Internal Parameters dialog box opens.
- In the edit box, type the name of the parameter you need to add and then click it.
- The parameter is added to the table below the search box with its default value.
- Change the default value as required.
- To reset the parameter value to its default, click the "Restore default value" icon at the end of the row.
Settings summary
You can view a summary of your settings by clicking the Setting Summary link. This is useful if you need to send a summary of your settings to Qlik Support.